﻿
Declare
	@ID uniqueidentifier

Delete JmdSite

insert into jmdsite
(
	ID, ParentSiteID, AliasSiteID, SiteURL, SiteFolder
)
values
(
  newid(), null, null,'jmdcms.com', 'jmdcms'  
) 

Select
	@ID = ID
From
	JmdSite
Where
	SiteURL = 'jmdcms.com'	
		

insert into jmdsite
(
	ID, ParentSiteID, AliasSiteID, SiteURL, SiteFolder
)
values
(
  newid(), @ID, null,'forums.jmdcms.com', 'jmdcms/forms'  
) 

insert into jmdsite
(
	ID, ParentSiteID, AliasSiteID, SiteURL, SiteFolder
)
values
(
  newid(), null, @ID,'alias.jmdcms.com', 'jmdcms'  
) 
